Copyright: ® 1996 Basic Systems, Inc.


Help Contents
Contents

Introduction

What Does Win, What, Where Do?

How Win, What, Where Works

Setup

Introduction

Display

Data

Startup

Inactivity

General

Screen Saver

Hot Key

Keyboard / Mouse Tracking

Administrator Mode

Project Tracking

W³ History

How Do I Get A Report?

Select Data

Detail Options

Search

Print

Export Data

Save / Open W³ Spreadsheet

Update Database (Ctrl+U)

Close All Spreadsheets

Exit

Edit

Window

Options Database

Options Spreadsheet

Spreadsheets

Summaries

Maintaining The Database

______________________________

Contacting Basic Systems

Support

Purchasing Information

Upgrades

License Agreement

Copyright and Trademark Information

Credits, Etc.

Wildcard Characters

"Like" Operator Examples

DOS Applications

Performance Tips

A Note About PROGMAN


What Does Win, What, Where Do?
What Does Win, What, Where Do?Win, What, Where Do?

Win, What, Where™ tracks all applications you run in Windows.   It logs when a program was launched and details how long that program ran.

Multi User capabilities let you gather usage information over the entire network.

Project Tracking adds the ability to group your activities based on a project.

Keyboard and Mouse Tracking give you a valuable insight into how your users are using the mouse and keyboard.

Win, What, Where won't get in the way.  Load it and forget it.  Your computer time and activities are recorded automatically.


How Win, What, Where Works
How Win, What, Where WorksWin, What, Where Works, What, Where Works, What, Where Works

Win, What, Where tracks the start and elapsed times for each application when the application gains focus.  W³ captures the application's caption along with the program name (EXE file name).  The application that has the focus is the active window.  The active window is generally the window in the foreground.  The application's caption is the window title bar (The top line of a window.)

W3.EXE is the program that actually does the data gathering.  It is normally run at all times by either selecting Load With Windows from Setup, or by selecting it from the Program Manager.  All setup options, online help, registration, and history functions are available from W3.EXE.

Summary Listings

The Summary Listing shows the total active time and the name of the Task.

Detail Listings

The Detail Listing shows every  task or activity in forward or reverse chronological order.  Each listing shows starting time, active time, and the name of the Task.


Setup - Introduction
Introduction•	Introduction•	Introduction•	Introduction

Setup determines the behavior and appearance of W³. Setup (WWWSETUP.EXE) may be run in two modes, User and Administrator.  If setup is accessed from the W³ main window only the options for that user will be available.  If  setup is run independently of W³ (from the Program Manager or from the File Manager) it will be in Administrator Mode.  Administrator Mode has additional capabilities such as setting options for individual or all users, taking users off-line, adding and deleting users, and defining the default settings.  Setup is organized into a series of tabs.


Display
Display•	Display•	Display•	Display

The display options set up what information about the current day's activities will be displayed when W³ is visible.  The display options do not affect what data is actually gathered, just the manner in which is displayed.

Related Topics:

What To Display

Field To Display

Start Time Display

Elapsed Time Display

Show Totals


What To Display

Configures what W³ will display on the Main Window.

Nothing

Displays nothing in the data section of W³'s main display.  Selecting this feature decreases the amount of time needed to load W³ and improves overall performance.

Detail

Display every activity.  Entry format: Start Time, Elapsed Time in format specified under Elapsed Time Display, and Description (as defined under Display Type).

Last Activity First

When Detail is selected, this option allows the entries to be listed in reverse chronological order.

Summary

Display a summary based on the selected Description for today's activities.


Field To Display

Select the type of data to be displayed.

•	Project Project Name

•	Caption Window Caption.  Contents of top line of active Window.  The active child window will also be displayed if "Monitor Child Windows" (see page Error! Bookmark not defined.) option is on.  If Project Tracking is active, the Project will also be displayed in brackets ([]).

•	Program Name With Path Executable file including the path.

•	Program Name Only Executable file without the path.


Start Time Display

Select 24 hour or AM/PM settings.


Elapsed Time Display

Elapsed Time may be displayed in several formats:

•	HH:MM:SS Standard default time display.  (Example:  02:43:21)

•	HH.MM Decimal hour time display.  (Example:  2.72 )

•	MMMM.SS Decimal minutes display.  (Example:  163.01)


Show Totals

Enable/disable total Elapsed/Inactive time display in the main window.  Disabling this feature improves performance.


Data

Setup where and how the data should be stored.  The Data Directories tab is subdivided into 3 additional tabs.

Related Topics:

Dirs

Auto Update

Workstation


Dirs

Select directory for data storage.  The default is the directory for W³, typically C:\WWW.  The directory must be entered as it is seen from the workstation.  For example, a user may see the Server's C: drive as F:.  The drive would be entered as F: here.

Local Data Directory / Main Data Directory

In some instances it will improve performance on a network if the individual user's daily data is stored on their workstation.  However, it is possible that when History performs the Detail File Update, the workstation will not be online.  If the Local and Main directories differ, W³ will copy the detail files from the local directory to the main directory when W³ starts or when the day changes.  Typically, the Main Directory will be on the network server.  On Single User setups, these directories should be the same.


Auto Update

One user per network, or single user may set a time here to automatically start History, consolidate the detail files, and exit.  Detail file consolidation can be a time consuming process and is best left to a time when the computer is idle.  Although a single user's detail file will typically take a minute to update, several hundred users can take hours.

This process can also be started from any scheduling program.  In the scheduler, use WWWHIST.EXE as the program name and the keyword UPDATE as the parameter.

Save Options

By default W³ saves each task switch, window change, etc.  immediately to disk.  This is done to insure that no activity is lost in the case of a computer malfunction.  In large network installations this can degrade W³'s performance.  Also, W³ will not log an activity to disk until it is finished, or switched away from.  In this case, if the computer locks up, all activity in the current task would be lost.

•	Save When Not Busy  Saves data when there has been at least 3 seconds of inactivity.

•	Save After Every Activity Safest method and also the slowest.  The program saves at each task switch.

•	Save Detail to disk after every NN entries Delays the writing of the detail records.  When NN entries have been accumulated, they are all written to disk at once.  Although this improves performance, if the computer locks up prior to the write then all NN entries will be lost.

•	Timed save detail to disk every NN minutes.  Forces a save based on a time interval.  This option is most useful when only a few applications are used.  The detail is also saved when a task is switched.  If this option has a value other than zero, it will be in effect.


Workstation

Displays the Workstation number that is automatically assigned and maintained by the program.   This display is provided for informational purposes.


Startup
Startup•	Startup•	Startup•	Startup

Normal Begin operation with default screen sizing.

Minimized Shrink to an icon.  Default setting.

Hidden Completely hide on startup.  W³ does not appear on the task list and there is no visible indication that W³ is running.  The Hot Key for Hidden Mode (Default setting: Shift+Ctrl+W) will toggle between hidden and normal mode.  Hidden mode uses the least amount of system resources and gives the best performance.

Hidden (No Hot Key) Same as above but with no hot key access.

Load With Windows

Check this box to load W³ when Windows starts.  This is all that needs to be done.  This places a reference to W³ in the RUN line of WIN.INI.  Do not place W³ in the Startup group.  Do not manually change the reference to W³ in the win.ini file.

Block All Exits

Removes all methods of ending W³.  W³ will not be available from the Task Manager, the Close menu item will be removed from the system menu, and Exit will be removed from the W³ menus.


Inactivity
Inactivity•	Inactivity•	Inactivity•	Inactivity

Inactive Time is logged when:

•	is off

•	There has been no keyboard or mouse activity for a set period of time

•	A screen saver is active

•	Windows is ended

•	The computer is off

Time outside of Windows is time when Windows has been ended or W³ is off.   It is entered automatically as WWW Off.  If the computer loses power or Windows is otherwise abnormally terminated, the time is logged as Abnormal Windows Shutdown.  If Windows is exited normally, the time is logged as Windows Ended.

Related Topics:

Ask For Inactivity Description

Require Inactivity Description

INACTIVE.INI


Ask For Inactivity Description

This option will pop up a dialog box allowing you to enter such things as  Lunch,  Fell asleep, etc.  The Inactivity Description feature pops up at the end of inactivity.   It occurs at the end of inactivity so you won't need to remember to log it in prior to leaving.  The dialog maintains a list of what has been entered before allowing you to build and select from  your own customized list.


Require Inactivity Description

This disables ESCAPE and Cancel in the Inactivity Dialog.  An Inactivity Description must be entered.

Begin Inactivity After...

Sets W³'s internal timer to begin inactivity after the described period of time has passed with no keyboard or mouse activity.  The default setting is 0, or off.  Normally, the screen saver can be used to determine this type of inactivity.


INACTIVE.INI

The entries are stored in a text file named INACTIVE.INI, located in the same directory as W³.  You can use any text editor such as NOTEPAD to delete or modify entries in this list.

Prompt For Project After Inactivity

If Project Tracking is enabled, selecting this option will also cause the Project dialog to appear after the normal Inactivity dialog.


General
General•	General•	General•	General

Monitor Caption Changes

Monitor Child Windows

Allow Access to Setup from W³

Monitor messages from Setup

Allow Access to History from W³


Monitor Caption Changes

By default, W³ captures the Window Caption when the application gains focus.  However, many applications change the caption after the program has loaded.  For example, Word For Windows typically starts up with DOCUMENT1 as the file in the caption.  This changes when a new file is loaded from the program.  In the default setting, W³ would not capture this.  By setting Monitor Caption Changes on, W³ will watch the caption and update as needed.


Monitor Child Windows

Set this option to monitor and include the active child window's caption in the detail file.  This option is most useful in applications that can have multiple documents (MDI) or windows open at the same time.


Allow Access to Setup from W³

Use to enable/disable access to the configuration program from W³.


Monitor messages from Setup

This is a performance option.  By leaving this option unchecked, W³'s performance can be enhanced.  When unchecked, any changes will not take effect until W3.EXE is restarted.

Checking this option will cause W³ to immediately react to messages sent by Setup.


Allow Access to History from W³

Use to enable/disable access to the history module from W³.


Screen Saver
Screen Saver•	  	Screen Saver•	  	Screen Saver•	  	Screen Saver

W³ logs all  Screen Saver programs as Inactivity.  If you are using a standard Windows Screen Saver (i.e., one that has a .SCR extension, or one that came with Windows) you will need to do nothing further.

A large selection of third party screen savers are available that do not necessarily conform to this standard and may require special handling.  If the screen saver tab does not list a screen saver or the one it lists is different than the one you use, do the following:

•	Press the "Find" button.

•	Manually start your screen saver.  Typically this can be accomplished by using its built in test function or by moving the mouse to a corner of the screen.

•	When your screen saver activates, press the F10 key.  W³ will capture the correct program name.

Note: If you are in Administrator Mode, this option will not be available.  It must be run from the workstation.


Hot Key
Hot Key.	Hot Key.	Hot Key.	Hot Key

Define the system hot keys used to Hide/Unhide W³ and to pop up the Project Selector.  Defaults are Shift+Ctrl+W for Hide/Unhide and Shift+Ctrl+P for Projects.


Keyboard / Mouse Tracking
Keyboard / Mouse Tracking/ Mouse Tracking/ Mouse Tracking/ Mouse Tracking

Related Topics:

Track Mouse Movement and Clicks

Display as ...

Mouse Calibration

Calibrate Mouse

Count Keystrokes

Display Keystrokes


Track Mouse Movement and Clicks

Enables mouse tracking.  Ever wonder how much mileage your mouse accumulates? Mouse Tracking keeps track of how far the cursor moves and allows you to relate that to how far you actually move the mouse on your desk.


Display as ...

Pick from a bewildering array of formats.  The format selected does not affect the actual data and may be changed at any time.


Mouse Calibration

Enter the physical distance that the mouse travels to move the cursor vertically (Y Axis) and horizontally (X Axis)  across the screen.  The default value is 1.5 inches which is appropriate for most mice.


Calibrate Mouse

This takes you to a program that will let you visually calibrate the mouse distances.  You will be able to print a calibration sheet and then simply move the mouse along the vertical and horizontal axis to properly calibrate the actual distances.


Count Keystrokes

Enabled Keystroke logging.  Disabling this feature will increase performance.


Display Keystrokes

Turns on/off display of keystrokes.  This does not affect whether or not keystrokes are actually monitored and saved.


Administrator Mode
Administrator ModeMode

Administrator Mode is entered by starting WWWSETUP.EXE from the program manager.  This mode allows you to edit, add, and delete individual users and to define the default operation of W³.

Administrator mode begins from the Select User Dialog.  The list on the left displays all users known to W³.  A · (checkmark) next to the user name indicates they are currently online and accepting messages from W³.  (See Monitor Messages from Setup).  An X (x mark) indicates they are online but are not monitoring messages from setup.  No mark indicates that they are not currently online.

An X may appear next to a user if Windows has been abnormally terminated.  This will clear once they are back online.

Select User (Administrator Mode)User (Administrator Mode)(Administrator Mode)(Administrator Mode)

Select User dialog is automatically entered when starting W³ in Administrator Mode.

Edit

Edit a User.  Pressing Edit will load the selected user's information and go into Setup.

Edit Default

This will allow you to set the default settings.  The Default settings are automatically applied when a new user is added.

New

Adds new user.  Displays the new user dialog.  Enter the user's name.  (Must be their Network Login Name)  If another user had been edited previously, then there will be an additional choice of "Use default settings" or "Use setting for NNN" NNN= previous user's name.

Delete

Removes a user from the system.

Take All Off-line / Take Off-line

Remotely ends W³ on a user's workstation.  If the user is monitoring messages from setup, these buttons will end W³ on their workstation.  This is useful prior to installing updates.  They can be brought back online by pressing "Put Online" or "Put All Online"

Exit

Ends Setup.

User Info

Pressing this button will display additional information about the users currently online.

Set To DefaultsSet To DefaultsTo DefaultsDefaults

Sets the current user to the default settings.

Save To AllSave To AllTo AllAll

Saves the current settings to all users.


Project Tracking
Project TrackingTracking

Project tracking provides a method of associating the activities monitored by W³ with a Project.  Projects may be assigned by pressing the Project Hot Key, double clicking on the Project Icon, or when a particular application has been started.

Related Topics:

Setup

Project Selector

Project Tracking Auto Prompt

Project Tracking Personal Project List


Setup - Project Tracking - Setup
Setup

Enable Project Tracking

This must be checked in order for Project Tracking to be enabled.

Use Group Titles From PROGMAN.EXE

Assigns Projects based on the Program Manager Group from which the application was launched.  By assigning your work to logical groups and enabling this feature, W³ will automatically assign Projects based on the Program Manager Group.  Projects are assigned without any further user intervention.

Note: PROGMAN.EXE.  Setup will display the current Program Manager defined in the Shell statement of SYSTEM.INI.

Do Not Assign Inactivity To Projects

This feature allows you to automatically exclude any inactivity from the active project by assigning all inactivity to a special project named Inactive.  If this option is not selected, the inactive time will be assigned to the current project.

Retain Current Project With EXE

While an application is running, retain the project that was originally assigned.  If you  set a Project while in an application, that Project will be recalled whenever that current application regains the focus.  Once that application has ended, the Project is no longer active.  For example, if you set the Project while in the File Manager (FILEMAN.EXE), whenever you return to the File Manager, the project initially assigned will once again become active.

When the "retain" feature is off, the Project will remain active until it is changed either by assignment from PROGMAN.EXE or by popping up the Project Selector.

Show Project as Icon when W³ is in Hidden Mode

Display current project as an Icon when W³ is in hidden mode.  A special Project Icon is displayed with the current Project shown in the caption.  Holding the mouse over the icon will pop up the Project Selector. (Same as using the Project Hot Key.)  This option uses less resources than having W³ visible and minimized.  The Project Icon will retain its location when reloaded.  To move the icon, press a mouse button and drag it to the new location.

Keep Project Icon On Top

Keep the Project Icon on top of all other windows.

Lock Projects

By default, new Projects may be added while the Project Selector window is popped up.  This option forces Projects to be selected from the current list.

Must Enter Project

When true, disables the Cancel button and Escape key in the Project Selector Window.  No default project is selected and the project must be entered.


Project Selector
Project SelectorSelector

Two types of Project Selectors are available.  The Standard selector is best for a small list of projects.  The Extended selector should be used  if you have over 200 projects or need to incorporate a project list from a larger database.

Standard Project SelectorProject SelectorSelector

The default Project Selector provides a simple text list of Projects the user has previously entered.

Extended Project SelectorProject SelectorSelector

The Extended Project Selector provides verification against a project database (WWWPROJ.MDB).  Projects entered using the Extended Project Selector must be in the database and only Projects listed in the database may be added.  All Personal Projects are validated against the project database once per day.

Related Topics:

Setting Up The Extended Project Selector

Using The Extended Project Selector

The structure of WWWPROJ.MDB

Using The Extended Project Selector


Setting Up The Extended Project Selector

When the Extended Project Selector is first selected, a button appears that will allow you to create a bare bones structure for the WWWPROJ.MDB database:

Pressing this button will create an empty database with the correct structure and indexing.  It is up to you to add data to this database.  This can be done directly from MS Access.


Setup - Project Selector - Using The Extended Project Selector
Using The Extended Project Selector


The structure of WWWPROJ.MDB

Table:     PROJECTS

Name	Type	Size	Attribute
PROJNUM	Text	20	Updatable
PROJDESC	Text	100	Updatable
Index: PROJNUM

Field Count:  1     Primary: No    Unique: Yes

Key	Order	Direction
PROJNUM	0	Ascending
PROJNUM	Use this field for the actual Project number or other defining information.  This is the information that will be added as the Project when selected.
PROJDESC	This field can be used to describe the project.  This will be seen when the Extended Project Selector is activated.


Setup - Project Selector - Using The Extended Project Selector
Using The Extended Project Selector

Each user has a separate list of Personal Projects.  When the Extended Project Selector is initially activated, these are the only projects that appear.  When the user wishes to add a new project, it must be selected from the master database, WWWPROJ.MDB.  The master database is displayed by pressing  the "New Project" button.

Adding a New Project

To add a project, select the desired project from the bottom list and press enter or double click.  If the project is already in the personal list, it will simply be highlighted.

Searching For Projects

You can search for a project by entering text into the "Search For" field and pressing First (Find the first match), Next, Prev (Previous), or Last.  Partial strings are accepted and standard wildcard matching is used.  If a string is found, it will be highlighted.

Close Project

This button will close the New Project portion of the window.


Project Tracking Auto Prompt
Project Tracking Auto Prompt(Auto Prompt)(Auto Prompt)(Auto Prompt)

This section provides methods for automatically popping up the Project Selector when the listed applications start.

EXE Browse

Opens a file selection dialog to select the appropriate files for the EXE List.

Include Path

Compare EXE's matching the exact path.  If the path is not included, any program matching the EXE name is considered, regardless of the path.

Auto Project Prompting Disabled

Disables Auto Project Prompting

Prompt when ANY Program Starts

Disregards the EXE list and prompts when any program starts.

Prompt only for Programs in list / Prompt for programs NOT in list

Determines when and what to prompt for.


Project Tracking Personal Project List
Project Tracking Personal Project List(Personal Project List)(Personal Project List)(Personal Project List)

This is the individual user's Personal Project List.  The list of projects may be different for each user.  Normally, this list is maintained from the Project Selector.

Default Project

The default project will be used when no other project is available.  Also, at start up this will become the current project.  If there is no Default Project, the last project will always be used until changed from the Project Selector.

Project Sorting

There are three methods available to sort Projects when they are displayed in the Project Selector:

1.	Alphabetic

2.	Last Item - sorts by most recent use.

3.	Nothing - No sorting performed.

Adding Projects

Projects can be added by entering the project into the top line of the project list.  When text is there, the Add button will become active.

If you are using the Extended Project Selector, there will be an additional button visible labeled "Add Projects From Database".  Pressing this button will display a window of the projects in WWWPROJ.MDB for selection.

If the Extended Project Selector is used and the Projects added are not in the database, they will be removed when the user pops up the Project Selector.

W³ History builds and maintains a MS Access 2 compatible database from the W³ detail files (*.WW3).  The daily detail files are merged into the main database by History.  All reports and printing functions are available from here.


How Do I Get A Report?
How Do I Get A Report?•	How Do I Get A Report?•	How Do I Get A Report?•	How Do I Get A Report?

The first thing you probably want to know is how to get a report out of History! The following brief introduction will show you the basic steps required to merge data into the database and generate a Detail and Summary report.

Get New Data From The Detail Files

By default, History will automatically do this when it is started.  To manually merge new data into the database, press CTRL+U.

Select The Data

Press the Select Data speed button and enter your selection parameters.

Show A Detail Listing

Detail Options will let you define and generate a detailed listing of the selected data.

Show A Summary Report

There are several predefined summaries available, or you can create your own custom report.


Select Data
Select Data•	Select Data•	Select Data•	Select Data

See How Do I Get A Report?

The select data dialog is used to select and filter data from the database that is then presented in the Detail and Summary spreadsheets.  Detail Spreadsheets always use the data selection.  With Summaries it is optional.

Select up to six criteria.  Each line consists of Field, Comparison, Parameter to match, and Match (How to Match).

If no selection criteria are entered the entire database will be selected.

Field

Select the field to be considered from the pull down selection box.  When a field has been selected, the List button (near the bottom of the window) will change to reflect the current field.

Is

Select the comparison method.

=	Equal to
<>	Not Equal
<=	Less Than Or Equal
>=	Greater Than Or Equal
Like Not Like	Used to compare two expressions. You can use the Like operator to find values in a field that match a pattern (in the Comparison Parameter column) you specify.  For a pattern, you can specify the complete value (for example, Like "Smith"), or you can use wildcard characters like those recognized by the operating system to find a range of values (for example, Like "Sm*"). In an expression, you can use the Like operator to compare a field value to a string expression.   For example, if you type Like "C*" in the Comparison Parameter , the query returns all field values beginning with the letter C.
See Wildcard Characters

Comparison Parameter

Enter the item to select.  There is a button near the bottom that changes its caption based on the data field selected.  (For example, if Date was in the Data Field, it would say "List Dates".)  Pressing this button will display all values in the database for that particular field.  You can double click or drag and drop this value into the comparison box.

If Like or Not Like have been selected in the IS column, Wildcard Characters may be used.

If an invalid value is entered for a field, it is displayed in RED.  Dates and Times may be entered in almost any format.  (For example: 12/17/94, December 17, 1994, 17 Dec 94, Dec. 17, 1994 are all acceptable.)

Match

Exact	The data must match the Comparison Parameter exactly.
Any	The Comparison Parameter can be anywhere in the data field.
Begin	Compare must be at the beginning.
End	Comparison at the end.
And / Or

And/Or is available when there are two or more criteria.  It is automatically set to And when a new line is begun.

And	If and only if both expressions evaluate true, the result is True.   If either expression evaluates false, the result is False
Or	If either or both expressions evaluate true, the result is True.
Load Detail/Summary

A Detail or Summary Spreadsheet may be loaded directly from Select Data by pressing this button.

Close

Close and save current parameters.

Parameters are maintained when W³ History is restarted.

Cancel

Cancel changes.

Clear All

Reset the selection criteria.

List...

Pressing the list button will display all data on file for the selected field.  Scroll through this list and either double click or drag & drop the data into the appropriate Comparison Parameter.


Detail Options
Detail OptionsOptions

Detail Options sets up how a Detail spreadsheet will be displayed.

Display

Check the fields to display.  Select only those fields of interest to increase performance.

Sort

Because of the database indexing scheme, the data will be automatically sorted by date, start time, and user in ascending order.  Use this feature to override or add additional sorting parameters.  Adding additional sorting parameters will decrease performance.

Grand Totals

Display Grand Totals on the last line (row) of the detail spreadsheet.  The fields that will be totaled (if displayed) are Elapsed Time, Keystrokes, Mouse Distance, and Mouse Clicks.

The format for the totals is set up in Maintenance/Spreadsheet

Virtual Mode

With very large spreadsheets (over 5,000 rows) Virtual Mode will give a substantial performance boost.  Virtual spreadsheets cannot be saved or searched.

Allow Editing

Allows editing in the Caption, Project, EXE, and User fields.  Will change only the current data item.  Edited data will not be placed back into the database.  To change the actual underlying data, use Maintenance/Edit Data.

Show SQL

Places the SQL statements in a special window.  This window is minimized after the query and can be copied into the clipboard and saved for use directly in Access or to aid in debugging.


Search
Search•	Search•	Search•	Search

Search is available when any non-virtual or saved spreadsheet is open.  Searches the active spreadsheet for information based on the entered parameters.

Fill in the selection parameters (Field, Is, Data, and Match) and press one of the direction buttons.  The resulting search will highlight the next row in the current spreadsheet.

Field

Select a field from the list box.  The list box will contain all data fields in the currently selected spreadsheet.

Is

Select an evaluation method.  (e.g., =, <>, <, etc.)

Data

Enter the data you wish to find.

Match

Select a matching method.

First, Next, Prev, Last

Execute the search.


Print
Print•	Print•	Print•	Print

Print is available when any spreadsheet is open.  Spreadsheets are printed as they appear on screen, using the same fonts, etc.

Print Range

Print the entire spreadsheet by selecting All or Selected Range will print the highlighted range of data.

Smart Print

Smart Print attempts to scale and resize the spreadsheet to best fit it to the printer's page size.

Smart Print follows these rules when resizing:

1.	If the number of columns are wider than a portrait page, the spreadsheet will print in landscape mode.

2.	If the information still will not fit, but will fit in landscape mode if the spreadsheet is reduced up to 60% its original size, the spreadsheet will be scaled to fit within  the page.

3.	If the information is still too wide,  the last attempt is to reduce the column widths to accommodate the widest string within each column.

4.	If all attempts to make the spreadsheet print within one page have failed, printing will resume normally in the current printer orientation with no reductions.

Print

The normal print routine.  This will print the spreadsheet as displayed with no additional formatting.

Printer Setup

The name of the Printer Setup Dialog Box is a little misleading.  You can use the dialog box to select any of your system's graphic output devices.  These devices are usually printers, but can also be another type of device, such as a fax modem.  In the interest of simplicity, this section will use "printer" to mean any graphic output device.

Selecting a Printer

You can use any of the printers that are available to your system.  You select a printer from the Printer Drop Down Box.

Setting the Page Orientation

There are two different page orientations, portrait and landscape.  On a standard piece of stationary paper (8½" by 11" in the U.S.), printing in portrait orientation will place the spreadsheet with its top toward one of the narrower sides, and printing in landscape orientation will place the spreadsheet with its top toward one of the wider sides.

To select an orientation:

1.	Click on its text or option button in the Orientation Group Box.

2.	Press <Alt> plus the option's underlined letter.

Selecting the Paper Size and Source

The printer determines which paper size and source options are available.  You select the size and source from the drop down boxes in the Paper Group Box.  (For some printers, one or both of the drop down boxes may be unavailable.)

Other Options

Selecting the Options Button opens a dialog box that is specific to the software or driver that operates the selected printer.  For help using the dialog box, try pressing <F1>, selecting the Help Button (if there is one), or referring to the appropriate documentation.


Export Data
Export DataData

Export is available when any spreadsheet is open.  Export will send the selected data to a text file delimited by commas or tabs.  The generated files can then be used to transfer W³ information to another application.

Note: If the spreadsheet has been opened in a non-virtual mode, you can simply highlight the desired data and use the copy command to place the data into the clipboard.  This information can then be easily pasted into the target application.

Spreadsheet

Select the spreadsheet to export.  All open spreadsheets are listed.  As you scroll through the list of open spreadsheets, the list of  Fields To Export  will change dynamically.

Fields To Export

The fields in the selected spreadsheet are listed.  By default, all fields are selected.  Use this feature to export only those fields of interest.

Output

Select Comma Separated Value (CSV) or TAB separated (TXT) file.  These two types of text files are readable by virtually every spreadsheet, database, and word processing application.

Overwrite/Append

If the selected file exists, the default will be to Append.

File

Select the output file.  If the file does not exist, it will be created.

Data

•	As Shown Send the data as formatted and displayed to the file.

•	Raw Send unformatted data to the file.  This will send dates and times out in their raw format.  Most spreadsheet applications can readily convert these values back to dates and times.

Text Options

•	Quotes Surround each data field with quotes.

•	Header Include a field description header as the first line.

Range (All, Rows)

Select the range to be exported.


Save / Open W³ Spreadsheet
Save / Open W³ Spreadsheet/ Open W³ Spreadsheet/ Open W³ Spreadsheet/ Open W³ Spreadsheet

W³ can save and read any spreadsheet created in History using a proprietary format.  Spreadsheets saved can be sent to another user with History and they can read and print them.  The saved spreadsheets contain all data and formatting.  W³ spreadsheets are saved with a SW3 extension.


Update Database (Ctrl+U)
Update Database (Ctrl+U)Database (Ctrl+U)(Ctrl+U)(Ctrl+U)

This will immediately update the database.  It will automatically select all pending detail files and perform the update.

Updating the database can take a long time depending on the number of users and their amount of activity.  This action can be executed automatically on a timed basis from the W³ Main program.

A scheduling program may also be used to implement this feature.  The command line is:

WWWHIST.EXE UPDATE


Close All Spreadsheets
Close All SpreadsheetsAll SpreadsheetsSpreadsheets

Closes all open spreadsheet windows.


Exit

End W³ History.  All current settings are saved.


Edit

Copy

This command lets you copy text to the Windows Clipboard so you can paste it elsewhere.  You can copy text within the same file or from one file to another.

Paste

When you move the insertion point and choose Paste, the text in the Windows Clipboard appears in the new position.  If there is nothing in the Clipboard, Paste is dimmed.


Window

Cascade

The Cascade command arranges all your open file windows in an overlapping pattern so that only the title bars are visible.

Tile

The Tile command arranges all your open file windows in a non-overlapping pattern, which allows you to see part or all of each one.

Arrange Icons

Arranges the icons evenly along the bottom of the main window.

1 to n command

When you click the Windows menu, a list of all open windows appears at the bottom of the menu.  The windows are numbered for reference.  Choosing any numbered item brings that window to the front, making it active.


Options Database

The individual detail files are not incorporated into the main database until the database is updated.  This dialog describes where and how to perform the update.

Database

Shows the location and name of the main database.  C:\WWW\WWW.MDB by default.  Use this selection to use a new or different database.  For example, if old data has been moved or copied to an archive database, this option can be used to make the archived database the current one.

If you do change the database temporarily, be sure to point back to the original when done.

Detail File Maintenance

Rename or Delete detail files after insertion into database.  If files are renamed, they are available in case the database needs to be rebuilt.  The current day's files are never deleted or renamed.

If you choose Rename, you will be responsible for manually deleting old detail files.  When files have been merged into the database they are renamed with an .XW3 extension.

Update Database When Loaded

Updates database every time History is started.  On by default.  If this is off, the database will need to be manually updated by pressing Ctrl+U or by coming to this dialog and selecting Update Now.

Allow Multi-User Access

Available in Network installations.  Deselecting this option will improve performance.  When this option is not checked, only one user will have access to the database at a time.

Database Information

see Database Information

Detail Files Waiting To Be Merged

Lists all detail files waiting to be updated.  Lists the User Name, Old or New file, and the Date.  All files are automatically selected.

You can see a list of users, workstation, and number of records for a particular file by double clicking on it.

Browse

Allows you to manually search and add detail files.

Browsing allows you to search your system for detail files that may not show up on the default "waiting to be merged" list.  This dialog will show both previously merged (.XW3) and new (.WW3) detail files.

Update Now

Merges the detail files into the database.

Updating can be a time consuming process depending on the number of detail files and the number of records in those files.  The update window does its best to keep you informed by displaying several progress indicators.

•	A list box on the left displays all files to be merged with the current file highlighted.

•	Current file's date and number of records.

•	Total number of records added

•	Progress indicator (percent done) bar shows the relative status of the update.

Save / Cancel

Save or Cancel any changes.  Closes the window.


Options Spreadsheet
Options Spreadsheet•	Spreadsheet•	Spreadsheet•	Spreadsheet

See How Do I Get A Report?

Determine how the spreadsheet will be displayed.  These settings also affect how the spreadsheet is printed.  A sample spreadsheet is displayed showing how your current selections will affect the output.

Date

The default date setting is the general date as described in the Control Panel.

Start Time

Set the start time format.

Elapsed Time

Elapsed time can be set to

HH:MM:SS	hours, minutes, and seconds
MMM.SS	Decimal Minutes
HHH.MM	Decimal Hours
Mouse Distance

Set the unit of measure used to display Mouse Distance.

Font, Foreground, Background

The fonts and colors can be set for both the Spreadsheet and Totals.

Grid Color

Select the spreadsheet color combinations.

Grids

Select how the spreadsheet grid is to be displayed.

Headers

Select which headers (Row and Column) are to be displayed.

Totals & Subtotals

The text used for Totals can be set here.  For example, you may wish to change Total: to Grand Total:.  Separate fonts and colors may also be selected.


Spreadsheets
Spreadsheets•	Spreadsheets•	Spreadsheets•	Spreadsheets

Adjusting Column Width·	Adjusting Column Width·	Adjusting Column Width·	Adjusting Column Width

Select the column whose width you want to adjust.

Drag the border at the right of the column heading until the column is the width you want.

Pressing the right mouse button will display a special column width / row height adjustment dialog.

This dialog will allow you to set both the row height and column width of the selected areas.

Getting Around The Spreadsheet·	Getting Around The Spreadsheet·	Getting Around The Spreadsheet·	Getting Around The Spreadsheet

The spreadsheet provides several methods of navigation.  Here are the onscreen controls.

Spreadsheet Shortcut Keys•	Spreadsheet Shortcut Keys•	Spreadsheet Shortcut Keys•	Spreadsheet Shortcut Keys

To	Press
Extend the selection by one cell	SHIFT+ arrow key
Extend the selection to the edge of the current data region	CTRL+SHIFT+ arrow key
Extend the selection to the beginning of the row	SHIFT+HOME
Extend the selection to the beginning of the spreadsheet	CTRL+SHIFT+HOME
Extend the selection to the last cell in the spreadsheet (lower-right corner)	CTRL+SHIFT+END
Select the entire column	CTRL+SPACEBAR
Select the entire row	SHIFT+SPACEBAR
Select the entire spreadsheet	CTRL+A
Collapse the selection to the active cell	SHIFT+BACKSPACE
Extend the selection down one screen	SHIFT+PAGE DOWN
Extend the selection up one screen	SHIFT+PAGE UP
Copy the selection	CTRL+C
Paste the selection	CTRL+V
Cut the selection	CTRL+X
Clear the selection of formulas and data	DELETE
Insert blank cells	CTRL+SHIFT+PLUS SIGN
Delete the selection	CTRL+MINUS SIGN
Undo the last action	CTRL+Z
Move one cell in a given direction	Arrow key
Move to the edge of the current data region	CTRL+ arrow key
Move between unlocked cells in a protected spreadsheet	TAB
Move to the beginning of the row	HOME
Move to the beginning of the spreadsheet	CTRL+HOME
Move to the last cell in the spreadsheet (in the lower-right corner)	CTRL+END
Move one screen down	PAGE DOWN
Move one screen up	PAGE UP
Move one screen to the right	ALT+PAGE DOWN
Move one screen to the left	ALT+PAGE UP
Move to the next sheet in the spreadsheet	CTRL+PAGE DOWN
Move to the previous sheet in the spreadsheet	CTRL+PAGE UP
Move to the next spreadsheet	CTRL+F6
Move to the previous spreadsheet	CTRL+SHIFT+F6
Move to the next pane	F6
Move to the previous pane	SHIFT+F6
Move one screen up or down	PAGE UP or PAGE DOWN
Move one screen to the right	ALT+PAGE DOWN
Move one screen to the left	ALT+PAGE UP
Display the next window	CTRL+F6 or CTRL+TAB
Display the previous window	CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
Scroll to display the active cell	CTRL+BACKSPACE
Turn scroll lock on or off	SCROLL LOCK
Scroll one row up or down	UP ARROW or DOWN ARROW (with Scroll Lock turned on)
Scroll one column left or right	LEFT ARROW or RIGHT ARROW (with Scroll Lock turned on)
Selecting a row, column, or spreadsheet

Single cell	Click the cell you want, or press the arrow keys to move to the cell you want.
Entire row or column	Click the row or column heading.
--Or--	Select a cell in the row or column.
Entire row	press SHIFT+SPACEBAR.
Entire column	press CTRL+SPACEBAR.
Entire spreadsheet	Click the Select All button (the square on the spreadsheet directly above the row headings and to the left of the column headings), or press CTRL+SHIFT+SPACEBAR.


Summaries
SummariesSummaries

See How Do I Get A Report?

Summaries are collections of records that are grouped and totaled in the manner you describe.

Select / Create Summary/ Create Summary/ Create Summary/ Create Summary

W³ comes with a variety of predefined summaries.  These can be used as is or as starting points to create your own.

Select Summary

Choose an existing summary from the drop down list box.

New

Press the New button to create a new summary.  This will clear the summary worksheet and automatically assign a name to the summary.  You may change the summary name at any time.

Summary Name

Summaries must have unique names.  When the New button is pressed, a Summary name is automatically generated.

Drag

Drag provides drag and drop to move the rows in the summarize area.  Place the cursor in the drag bar, press and hold the left button.  The selected row will change color to blue and the cursor will change to a pointing hand.

You can now move the row to another location in the summarize area.

Summarize

All data to be shown in a summary must first be listed here.  Fields listed with no CALC are automatically assigned as Group Items.  Summaries are grouped in the order that grouped items appear here.  Groups must appear first, followed by the calculated fields.  The calculated fields are what is actually being summarized.  For example, if you wanted to see Elapsed Time for a given period, you would place "Elapsed" as the final item in the Summarize area with "Date" above it.  Date would have no calculation and "Elapsed" would have "SUM".

Field

Field is the data you want to display.  If a field has no CALC associated with it, then it is a Group.  For example, Project followed by no CALC will generate a summary grouped by Project with the calculated fields displayed for each Project.  You can group on multiple items.  When you group on more than one item, the first field listed is the first and most significant group level; the second field is the next group level; and so on.

CALC

When a calculation is specified, the result will be displayed with the grouped item.  Calculated fields must appear after the Group fields.

The available calculations are:

•	SUM Returns the sum of a set of values contained in a specified field on a query, form, or report.

•	COUNT Calculates the number of selected records.

•	AVG Average.  Calculates the arithmetic mean of a set of values.

•	MIN Return the minimum of a set of values.

•	MAX Return the maximum of a set of values.

Sort

Group fields may be sorted.  No sorting occurs when the Sort column is blank.  Groups may be sorted in ASC (ascending) or DESC (descending) order.

Subtotal

The Summary may be subtotaled by Group.  The subtotal will appear at the end of each group's calculated fields section.

Show Totals

Totals for the calculated fields will be displayed on the last line of the resulting spreadsheet.

Related Topics:

How to Split the Active / Inactive Times in a Summary


How to Split the Active / Inactive Times in a Summary
How to Split the Active / Inactive Times in a Summary•	How to Split the Active / Inactive Times in a Summary•	How to Split the Active / Inactive Times in a Summary•	How to Split the Active / Inactive Times in a Summary

To create a "cross-tab" summary that splits active and inactive times on one line requires a special syntax.

Placing the field Inactive after Elapsed will cause the summary to split the summed elapsed time into two additional columns named Inactive and Active.

This will create a spreadsheet showing the total elapsed time, followed by inactive and active times.


Maintaining The Database
Maintaining The DatabaseThe DatabaseDatabase

Repair Database

Compact Database

Delete Data

Edit Data

Verify / Rebuild Indexes

Database Information

Rebuild Database

Debug Info


Repair Database
Repair DatabaseDatabase

In most cases, History will automatically detect if the database is damaged and give you the option to repair it.  In some situations, History may not detect that a database is damaged.  If a database behaves unpredictably, perform the following procedure.

Backup

This will make a copy of the database to WWWBAKNN.MDB, where NN is an automatically incremented number.

Compact After Repair

This option will automatically begin the Compact Database procedure after the repair.

It is strongly recommended that Backup and Compact After Repair be used.


Compact Database
Compact DatabaseDatabase

If you delete records, your database can become fragmented and use disk space inefficiently.  Compacting the database makes a copy of the database, rearranging how the database file is stored on disk.


Delete Data
Delete DataData

Delete data provides a method to delete or move database records from the main database.  The records can be moved to an archive database that can later be accessed for archival information.  Deleting or moving records will help keep the database small (and fast).

If you want to delete all records, exit History and simply delete the database from File Manager or Explorer.

Selecting The Records To Be Deleted

•	Use Date Selections  Let's you define how many Months, Days, or Years to delete.  The dialog displays the date up to which records will be deleted. WARNING:  Entering a 0 here will delete all records!

•	Use Current Data Selection Sets the deletion parameters to the current data selection  (see Select Data).

Backup Current Database

Makes a copy of the database prior to deleting records.  W³ will suggest a unique name for the backup database.  You may enter another name.

Move Deleted Records To Archive Database

As the records are deleted, place a copy of that record in the described archive database.  If the archive database does not exist, W³ will create it.  Archive databases can be used to keep the History database small, fast,  and manageable.  They also have the added benefit of still having the information on hand in case later reports need to be generated.  Archive databases can be set as the current database in Database Options.

Be careful not to leave an archived database set to the current database.  This will cause updates to be applied to the archive database!

Preview

Preview will load a Detail spreadsheet showing all records that will be deleted using the current parameters.


Edit Data
Edit DataData

Edit data is provided as a method to directly edit the underlying data in the W³ Database.  This should not be used in normal operation and is provided as a "last ditch" method of editing the data.  It will allow you to directly alter the contents of the database with no verification.

For example, you could use Edit Data to change the underlying text in a Caption.  This would change that particular caption in every record.

Fields displayed in Red cannot be edited.

Save

Save the changes.

Undo

Do not save the changes.

Find

Bring up the Search dialog.

Replace

This command lets you replace one character string with another in some or all of the places it occurs in the selected table of the database.  You specify both the text pattern to search for and the pattern you want to replace it with  (See Wildcard Characters for information on pattern matching).

The data from the current record is automatically placed in the first field.

•	Replace Matching Portion Only This will cut and paste only the portion of the record that matches.

•	Replace Entire Record This will replace the entire contents of the matching records with the replacement text.


Verify / Rebuild Indexes
Verify / Rebuild Indexes/ Rebuild Indexes/ Rebuild Indexes/ Rebuild Indexes

Generally, this is handled automatically by History.  There is no dialog associated with this command and it reports nothing if everything is OK.  It will display a status at the bottom of the main History window if it adds or modifies any indexing scheme.


Database Information
Database InformationDatabase InformationInformation

Displays detailed information about the database.  The top portion of the window displays the tables in the database and the lower portion displays the indices in the selected table.


Rebuild Database
Rebuild DatabaseDatabase

Rebuild database will read old (.XW?) and new detail files and perform a complete rebuild of the W³ database.  Use this feature if the database has become corrupted or has been deleted.  The current database will be completely rebuilt.  Any existing records will be lost.

This dialog is the same as Database Options


Debug Info
Debug InfoInfo

Debug Info is available in Maintenance and Summary.  It provides information needed by Basic Systems when diagnosing any problems you may have.  Information is provided in the window on how to email or fax it to us.


Contacting Basic Systems
Contacting Basic Systems•	Contacting Basic Systems•	Contacting Basic Systems•	Contacting Basic Systems

Basic Systems, Inc.  925 West Kennewick Ave.  Kennewick, WA 99336
Phone	(509) 585-9293
Fax	(509) 585-9294
CompuServe	70034,1341
America Online	BasicWWW
Internet	70034.1341@compuserve.com
Web Site	http://www.owt.com/basic


Support
Support•	Support•	Support•	Support

Technical support for W³ is available to all registered users.  If you are not a registered user, we will provide limited assistance to help you install and become sufficiently proficient for proper evaluation.

Full Technical Support following registration is available by phone.  However, we encourage you to use electronic mail to contact us.  We have access to the common online services and we visit them often.   Email allows for more concise questions as well as more detailed answers.


Purchasing Information

Copies	Description	Price	Total
	Single User (Disks & Manual)	$37.00
	Network Starter Pak (Initial Network installation + License for 3 users) (Disks & Manual)	$99.00
	Additional Network Licenses (Requires Network Starter Pak)	$15.00 ea.
		Total
To Order By Check

Name:
Company:
Address:
City State Zip
Phone:
Email:
Send to:

Basic Systems, Inc.

925 West Kennewick Ave.

Kennewick, WA 99336

Payment must be in US dollars drawn on a US bank.

To Order By Credit Card

You can order with MC, Visa, Amex, or Discover from Public (software) Library by calling

1-800-242-4775

or 713-524-6394 or by FAX to 713-524-6398 or by CIS Email to 71355,470. You can also mail credit card orders to:

PsL

P.O.Box 35705

Houston, TX 77235-5705.


Upgrades
Upgrades•	Upgrades•	Upgrades•	Upgrades

Upgrade protection!  We are always improving W³.  At some point in the future you may find a newer version of W³.  Registered users can simply install the newer version, enter the Registration Name & Number from the older version and consider your new version registered!  The new software will display your name and company information on the About screen and will eliminate any registration screens.  This feature will work for all new versions at least up until the next major release.

The latest version of Win, What, Where can always be found at the following locations:

http://www.owt.com/basic	Basic Systems' internet web site. Go to the "Download" section.
CompuServe	GO WINSHARE Look for W3.ZIP in the Windows Shareware Forum.
AOL	Keyword Windows Forum Look for W3.ZIP in Notable Downloads.


License Agreement
License AgreementAgreement

LICENSE. This license permits you to use Win, What, Where on a single computer network. The number of computers authorized to use this product on the computer network is governed by the accompanying registration number and license code. Note: This software is licensed to computers, not to users.

RESTRICTIONS. You may not rent or lease Win, What, Where, but you may transfer the right to use Win, What, Where on a permanent basis provided you transfer the software and all written materials accompanying the software and retain no copies. Any transfer of software must include the most recent update and all prior versions.

COPYRIGHT. Win, What, Where is owned by Basic Systems, Inc. and is protected United States copyright laws and international treaty provisions.

LIMITED WARRANTY. Basic Systems, Inc. warrants that the media on which Win, What, Where is distributed will be without defect for a period of 90 days from the date of receipt. Basic Systems, Inc. makes no representation or warranty regarding the results obtainable through use of this software.

CUSTOMER REMEDIES. Basic Systems, Inc.'s entire liability and your exclusive remedy shall be at Basic Systems, Inc.'s option, either (a) return of the price paid or (b) replace the media on which Win, What, Where is distributed.

NO OTHER WARRANTIES. Basic Systems, Inc. disclaims all other warranties, either express or implied, including but not limited to implied warranties of merchantability and fitness for a particular purpose, with respect to Win, What, Where, and its accompanying written materials.

NO LIABILITY FOR CONSEQUENTIAL DAMAGES. In no event shall Basic Systems, Inc. or its suppliers be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use Win, What, Where, even if Basic Systems, Inc. has been advised of the possibility of such damages.

This License Agreement is governed by the laws of the State of Washington.

We have reason to believe that you are the only person to have read this agreement.


Copyright and Trademark Information
Copyright and Trademark Informationand Trademark InformationTrademark InformationTrademark Information

Win, What, Where™ Copyright © 1993-1996 Basic Systems, Inc.  All Rights Reserved.

Win, What, Where™ is a trademark of Basic Systems, Inc.

All other product names may be copyright and registered or unregistered trademarks / tradenames of their respective owners.


Credits, Etc.

Proofing	Jill Dubois The Corner Office PO Box 303 Bourbonnais IL 60914 (815) 939-0606 75521.1732@compuserve.com	Lead Tormentor	Gary B. Banko ISM Consulting 3811 Stansbury Mill Road Phoenix, MD   21131 (410) 683-6931 72436.1427@compuserve.com http://ourworld.compuserve.com/homepages/gbanko
Special Thanks	Rachel, Isaac, Susie, Fred, and Ruby
Mr. Eaton's Hair	Mr. Rudy
Mystery Quote	…they will call you Sir and shine your shoes.


Wildcard Characters
Wildcard CharactersCharacters

The asterisk (*), question mark (?), number sign (#), exclamation point (!), hyphen (-), and brackets ([ ]) are wildcard characters.  You can use these characters to select data in the History module to include all records that begin with specific characters or match a certain pattern.  You can also use wildcard characters and matching characters to further refine a search.

*	wh* finds what, white, and why*at finds cat, bat, and what	Like the MS-DOS asterisk (*) wildcard character, this asterisk matches any number of characters.  But unlike MS-DOS, it can be used as the first or last character in the character string.
?	b?ll finds ball, bell, and bill	Like the MS-DOS ? wildcard character, this symbol matches any single character.
#	1#3 finds 103, 113, 123	Matches any single digit.
[ ]	b[ae]ll finds ball and bell but not bill	Matches any single character within the brackets.
!	b[!ae]ll finds bill and bull but not bell	Matches any character not in the list.
-	b[a-c]d finds bad, bbd, and bcd	Matches any one of a range of characters.
Note:   The wildcard characters *, ?, #, [ can match themselves only if enclosed in brackets.  For example, to search for a question mark, you would enter [?].


"Like" Operator Examples
"Like" Operator Examples Operator Examples Examples

The following table shows how you can use Like to test expressions for different patterns.

Kind of match	Pattern	Match	No match
Multiple characters	"a*a"	"aa", "aBa", "aBBBa"	"aBC"
"*ab*"	"abc", "AABB", "Xab"	"aZb", "bac"
Special character	"a[*]a"	"a*a"	"aaa"
Multiple characters	"ab*"	"abcdefg", "abc"	"cab", "aab"
Single character	"a?a"	"aaa", "a3a", "aBa"	"aBBBa"
Single digit	"a#a"	"a0a", "a1a", "a2a"	"aaa", "a10a"
Range of characters	"[a-z]"	"f", "p", "j"	"2", "&"
Outside a range	"[!a-z]"	"9", "&", "%"	"b", "a"
Not a digit	"[!0-9]"	"A", "a", "&", "~"	"0", "1", "9"
Combined	"a[!b-m]#"	"An9", "az0", "a99"	"abc", "aj0"


DOS Applications
DOS ApplicationsApplications

W³ can monitor DOS applications when they are executed through Windows in a DOS shell.  If the application is run full screen, W³ may not be able to supply a caption, however, a DOS session will be noted in the Executable name as WINOA386.MOD.   If a DOS session is run "windowed" (not full screen), W³ will be able to capture the standard Window Title Bar.

The W³ Inactivity Monitor will only be able to sense mouse activity in a DOS application.  This means that the Inactivity Monitor may log time as inactive even though there has been keyboard activity.  The solution to this is to either turn off the Inactivity Monitor or move the mouse occasionally while in a DOS application.  If Keystroke monitoring is on, it will not be able to count keystrokes while in the DOS window.


Performance Tips
Performance TipsTips

•	Run in Hidden Mode This keeps W³ down to about 3% of system resources and memory requirements are also considerably less.

•	Show Project as Icon when W³ is in Hidden Mode and using Project Tracking.

•	Don't use Monitor Messages from Setup Located in the General tab of Setup.

•	Network users - select a Local Data Directory that is on the user's workstation.  This will  cause W³ to write the detail file to the local drive, decreasing network traffic.

•	Use Write When Not Busy

•	Turn off Mouse and Keyboard monitoring.

•	Use the windows Screen Saver to indicate Inactivity. Set the times in Setup - Inactivity to 0.

History

•	Use Virtual Mode for very large Detail Spreadsheets.

•	Turn off Allow Editing in Detail Spreadsheets.

•	Do not use Grand Totals in Detail Spreadsheets.

•	Turn off Allow Multi-User Access in Options / Database.

•	Turn off Update When Loaded in Options / Database.

•	Use the Auto Update feature in Setup to update the database during off hours.

•	Only include fields of interest in a Detail Spreadsheet.  For example, if you never look at Keystrokes, then leave that box unchecked.

•	Keep sort levels to a minimum in Detail and Summary Spreadsheets.

•	Keep the database small.  Move or delete records that are no longer of interest.


A Note About PROGMAN
A Note About PROGMAN•	A Note About PROGMAN•	A Note About PROGMAN•	A Note About PROGMAN

We have used PROGMAN and Program Manager throughout this manual when talking about the Windows Shell.  The shell  can actually be almost anything.    In Windows 95, the default shell is set to EXPLORER.